public function get($options = []) {
  $result = [];

  $sqlParts = [
    'select'	=> ['users' => 'u.userid'],
    'from'		=> ['users' => 'users u'],
    'where'		=> [],
    'order'		=> [],
    'limit'		=> null
  ];

  $defOptions = [
    'usrgrpids'					=> null,
    'userids'					=> null,
    'mediaids'					=> null,
    'mediatypeids'				=> null,
    // filter
    'filter'					=> null,
    'search'					=> null,
    'searchByAny'				=> null,
    'startSearch'				=> false,
    'excludeSearch'				=> false,
    'searchWildcardsEnabled'	=> null,
    // output
    'output'					=> API_OUTPUT_EXTEND,
    'editable'					=> false,
    'selectUsrgrps'				=> null,
    'selectMedias'				=> null,
    'selectMediatypes'			=> null,
    'selectRole'				=> null,
    'getAccess'					=> null,
    'countOutput'				=> false,
    'preservekeys'				=> false,
    'sortfield'					=> '',
    'sortorder'					=> '',
    'limit'						=> null
  ];
  $options = zbx_array_merge($defOptions, $options);

  // permission check
  if (self::$userData['type'] != USER_TYPE_SUPER_ADMIN) {
    if (!$options['editable']) {
      $sqlParts['from']['users_groups'] = 'users_groups ug';
      $sqlParts['where']['uug'] = 'u.userid=ug.userid';
      $sqlParts['where'][] = 'ug.usrgrpid IN ('.
        ' SELECT uug.usrgrpid'.
        ' FROM users_groups uug'.
        ' WHERE uug.userid='.self::$userData['userid'].
      ')';
    }
    else {
      $sqlParts['where'][] = 'u.userid='.self::$userData['userid'];
    }
  }

  // userids
  if ($options['userids'] !== null) {
    zbx_value2array($options['userids']);

    $sqlParts['where'][] = dbConditionInt('u.userid', $options['userids']);
  }

  // usrgrpids
  if ($options['usrgrpids'] !== null) {
    zbx_value2array($options['usrgrpids']);

    $sqlParts['from']['users_groups'] = 'users_groups ug';
    $sqlParts['where'][] = dbConditionInt('ug.usrgrpid', $options['usrgrpids']);
    $sqlParts['where']['uug'] = 'u.userid=ug.userid';
  }

  // mediaids
  if ($options['mediaids'] !== null) {
    zbx_value2array($options['mediaids']);

    $sqlParts['from']['media'] = 'media m';
    $sqlParts['where'][] = dbConditionInt('m.mediaid', $options['mediaids']);
    $sqlParts['where']['mu'] = 'm.userid=u.userid';
  }

  // mediatypeids
  if ($options['mediatypeids'] !== null) {
    zbx_value2array($options['mediatypeids']);

    $sqlParts['from']['media'] = 'media m';
    $sqlParts['where'][] = dbConditionInt('m.mediatypeid', $options['mediatypeids']);
    $sqlParts['where']['mu'] = 'm.userid=u.userid';
  }

  // filter
  if (is_array($options['filter'])) {
    if (array_key_exists('autologout', $options['filter']) && $options['filter']['autologout'] !== null) {
      $options['filter']['autologout'] = getTimeUnitFilters($options['filter']['autologout']);
    }

    if (array_key_exists('refresh', $options['filter']) && $options['filter']['refresh'] !== null) {
      $options['filter']['refresh'] = getTimeUnitFilters($options['filter']['refresh']);
    }

    if (isset($options['filter']['passwd'])) {
      self::exception(ZBX_API_ERROR_PARAMETERS, _('It is not possible to filter by user password.'));
    }

    $this->dbFilter('users u', $options, $sqlParts);
  }

  // search
  if (is_array($options['search'])) {
    if (isset($options['search']['passwd'])) {
      self::exception(ZBX_API_ERROR_PARAMETERS, _('It is not possible to search by user password.'));
    }

    zbx_db_search('users u', $options, $sqlParts);
  }

  // limit
  if (zbx_ctype_digit($options['limit']) && $options['limit']) {
    $sqlParts['limit'] = $options['limit'];
  }

  $userIds = [];

  $sqlParts = $this->applyQueryOutputOptions($this->tableName(), $this->tableAlias(), $options, $sqlParts);
  $sqlParts = $this->applyQuerySortOptions($this->tableName(), $this->tableAlias(), $options, $sqlParts);
  $res = DBselect(self::createSelectQueryFromParts($sqlParts), $sqlParts['limit']);

  while ($user = DBfetch($res)) {
    unset($user['passwd']);

    if ($options['countOutput']) {
      $result = $user['rowscount'];
    }
    else {
      $userIds[$user['userid']] = $user['userid'];

      $result[$user['userid']] = $user;
    }
  }

  if ($options['countOutput']) {
    return $result;
  }

  /*
   * Adding objects
   */
  if ($options['getAccess'] !== null) {
    foreach ($result as $userid => $user) {
      $result[$userid] += ['gui_access' => 0, 'debug_mode' => 0, 'users_status' => 0];
    }

    $access = DBselect(
      'SELECT ug.userid,MAX(g.gui_access) AS gui_access,'.
        ' MAX(g.debug_mode) AS debug_mode,MAX(g.users_status) AS users_status'.
        ' FROM usrgrp g,users_groups ug'.
        ' WHERE '.dbConditionInt('ug.userid', $userIds).
          ' AND g.usrgrpid=ug.usrgrpid'.
        ' GROUP BY ug.userid'
    );

    while ($userAccess = DBfetch($access)) {
      $result[$userAccess['userid']] = zbx_array_merge($result[$userAccess['userid']], $userAccess);
    }
  }

  if ($result) {
    $result = $this->addRelatedObjects($options, $result);
  }

  // removing keys
  if (!$options['preservekeys']) {
    $result = zbx_cleanHashes($result);
  }

  return $result;
}

while ($user = DBfetch($res)) {
  unset($user['passwd']);

  if ($options['countOutput']) {
    $result = $user['rowscount'];
  }
  else {
    $userIds[$user['userid']] = $user['userid'];

    $result[$user['userid']] = $user;
  }
}

protected function addRelatedObjects(array $options, array $result) {
  $result = parent::addRelatedObjects($options, $result);

  $userIds = zbx_objectValues($result, 'userid');

  // ......

  // adding user role
  if ($options['selectRole'] !== null && $options['selectRole'] !== API_OUTPUT_COUNT) {
    if ($options['selectRole'] === API_OUTPUT_EXTEND) {
      $options['selectRole'] = ['roleid', 'name', 'type', 'readonly'];
    }

    $db_roles = DBselect(
      'SELECT u.userid'.($options['selectRole'] ? ',r.'.implode(',r.', $options['selectRole']) : '').
      ' FROM users u,role r'.
      ' WHERE u.roleid=r.roleid'.
      ' AND '.dbConditionInt('u.userid', $userIds)
    );

    foreach ($result as $userid => $user) {
      $result[$userid]['role'] = [];
    }

    while ($db_role = DBfetch($db_roles)) {
      $userid = $db_role['userid'];
      unset($db_role['userid']);

      $result[$userid]['role'] = $db_role;
    }
  }

  return $result;
}